package com.credit.repository;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.credit.entity.CreditLoanOrder;

public interface CreditOrderDao extends PagingAndSortingRepository<CreditLoanOrder, Long>, JpaSpecificationExecutor<CreditLoanOrder> {

	@Query("from CreditLoanOrder order where order.processFlag=1044 and order.orderType=?1 and order.flushTime<?2")
	List<CreditLoanOrder> findOrderListByFlushTime(Integer orderType,Date lastDay);

}
